package com.ghao.douban.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ghao.douban.Entity.MovieInfo;
import com.ghao.douban.Entity.SysUser;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author Ghao
 * @date 2021/7/19 16:03
 */
public interface SysUserMapper extends BaseMapper<SysUser> {

    @Select("select password from sys_user where username = #{username} limit 1;")
    String selectPasswordByName(@Param("username") String username);

    @Select("select perm from sys_user where username = #{username}")
    String selectPermByName(@Param("username") String username);
}
